SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 306;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('306', 'Cash Crusaders The Corner','Kitshoff Managing Group (Pty) Ltd','Cash Crusaders The Corner','Shop 4, The Corner, 337 Robert Sebukwe Street, Sunnyside','TBA','4340303298','2020/787235/07','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders The Corner',CompanyName = 'Kitshoff Managing Group (Pty) Ltd', TradingAs = 'Cash Crusaders The Corner', Address='Shop 4, The Corner, 337 Robert Sebukwe Street, Sunnyside', ContactNo = 'TBA', VATRegNo = '4340303298',RegNo = '2020/787235/07', StoreEmailAddress = 'TBA' where Store_ID = 306;
 END


 SET IDENTITY_INSERT [dbo].[store] off